You are here: Web Administration > Integration > KommerceServer Import API Specifications

 

KommerceServer Import API Specifications

Following is a list of export APIs that are available to you in KommerceServer.

Export API Name

Description of Use

Available in webPortal?

Available in webStore?

KS_BASE_PRICES

Extended site specific item information (e.g. Price Sheet)

No

Yes

KS_CATEGORY

Internal category for Items

Yes

Yes

KS_CLASSIFICATIONS

Business and/or contact classification codes

No

No

KS_COMMISSIONS

Commission detail data from invoices and adjustments

No

No

KS_COMPETITOR_XREFS

Cross reference of competitor items to sellable items

No

{Yes}

KS_COMPETITORS

Collection of companies selling competitive products (products will be cross-referenced)

No

{Yes}

KS_CONTACTS

Contacts for customers or end users

Yes

Yes

KS_CURRENCY

Currency Codes

{Yes}

{Yes}

KS_CUST_PARTS

Customer cross reference part numbers to host company part numbers.

No

{Yes}

KS_CUSTOMERS

Customer information with primary address

Yes

Yes

KS_DEPARTMENTS

Hierarchical sales department structure for the host company (not for use by external customers)

No

No

KS_ENDUSERS

End Users are companies that are indirect customers via dealers/distributors (Parallel dataset to KS_CUSTOMERS)

No

No

KS_EXCHG_RATES

Current exchange rates from the foreign currency code to the functional currency of the website

{Yes}

{Yes}

KS_FAILURE_CODES

List of failure codes related to Return Material Authorizations or service calls

No

No

KS_FREIGHT

Shipping Methods and estimated freight rates by weight or amount

No

Yes

KS_GEO_RESTRICTIONS

Geographical restriction data used by the storefront to prevent shipments to locations for certain products

No

{Yes}

KS_INVENTORY

Inventory for items by inventory location

No

{Yes}

KS_INVOICES

Invoice transactions for sales orders, RMAs, and manual invoices

Yes

No

KS_MFG_ITEMS

Basic item master information

Yes

Yes

KS_MODELS

Product Models with associated option and rule sets

No

No

KS_OPTIONS

Product configurator Option Sets (not specific to a particular model)

No

No

KS_ORDERS

Sales Order transactions including line item and delivery information

Yes

No

KS_PRICE_ADJS

Price discounts or markups by volume and combination of customer, customer class, product, or product class

No

Yes

KS_QUOTES

Sales quotations for prospects and customers

No

No

KS_REGIONS

Hierarchical sales regions with associated sales reps

No

No

KS_REPQUOTA

Sales quota by sales rep for reporting purposes

No

No

KS_RMA_RECEIPTS

Return Material Authorization receipt transactions (parallel dataset to KS_SHIPMENTS)

Yes

No

KS_RMA_TYPES

List of Return Material Authorization types

No

No

KS_RMAS

Return Material Authorization transactions including line item and delivery information (parallel dataset to KS_ORDERS)

Yes

No

KS_RULES

Product configurator Rule Sets (not specific to a particular model)

No

No

KS_SALES_TAX

Sales tax codes and tax rates

No

Yes

KS_SERIALHIST

Serial Controlled Item transaction cross reference and warranty information

{Yes}

No

KS_SERVICE_CHARGES

Service charges related to service calls

No

No

KS_SERVICE_TYPES

List of various labor services performed on service calls

No

No

KS_SHIP_ADDRS

Additional office location addresses for customers (i.e. warehouse, sales office, etc.)

No

Yes

KS_SHIPMENTS

Shipment transactions for sales orders; Also supported reverse shipments (i.e. receipts which are treated like RMAs)

Yes

No

KS_SPECIAL_CHARGES

Special Charge Codes which are associated to store items

{Yes}

{Yes}

KS_WAREHOUSE_ITEMS

Base prices for items by price code (i.e. Price Lists)

No

{Yes}

KS_WARRANTY_CODES

Warranty codes related to serial controlled items

No

No